| FaaProcessExceptionDataChange |
| EntityType | Independent |
| Logical Entity Name | FaaProcessExceptionDataChange |
| Default Table Name | SyServiceExceptionAudit |
| Logical Only | NO |
| Definition | |
| Note |
| FaaProcessExceptionDataChange Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
Id |
INTEGER | NO | ||
| ExceptionHashIdentifier | NUMERIC(20, 0) | NO | ||
FaaProcessExceptionActionId |
INTEGER | NO | ||
PreviousFaaProcessExceptionStatusId |
INTEGER | YES | ||
NewFaaProcessExceptionStatusId |
INTEGER | NO | ||
PreviousAssignedStaffId |
INTEGER | YES | ||
NewAssignedStaffId |
INTEGER | YES | ||
PreviousAssignedStaffGroupId |
INTEGER | YES | ||
NewAssignedStaffGroupId |
INTEGER | YES | ||
PreviousReviewStaffId |
INTEGER | YES | ||
NewReviewStaffId |
INTEGER | YES | ||
NewReviewStaffGroupId |
INTEGER | YES | ||
PreviousReviewStaffGroupId |
INTEGER | YES | ||
PreviousLockedStaffId |
INTEGER | YES | ||
NewLockedStaffId |
INTEGER | YES | ||
| PreviousLockedDateTime | DATETIME | YES | ||
| NewLockedDateTime | DATETIME | YES | ||
| Note | NVARCHAR(max) | NO | ||
| PreviousDataValues | XML | NO | ||
| NewDataValues | XML | NO | ||
| SnoozeUntilDate | DATETIME | YES | ||
| ExpiresOnDate | DATETIME | YES | ||
LastModifiedUserId |
INTEGER | NO | ||
| CreatedDateTime | DATETIME | NO | ||
| LastModifiedDateTime | DATETIME | NO | ||
| RowVersion | TIMESTAMP/DATE | NO | ||
| IsEscalatedPrevious | BIT | NO | ||
| IsEscalatedNew | BIT | NO |
| FaaProcessExceptionDataChange Keys |
| Key Name | Key Type | Keys |
| Nk_SyServiceExceptionAudit_UserId | Inversion Entry | LastModifiedUserId |
| Nk_SyServiceExceptionAudit_ExceptionHashId | Inversion Entry | ExceptionHashIdentifier |
| PK_SyServiceExceptionAudit_SyServiceExceptionAuditId | PrimaryKey | Id |
| FaaProcessExceptionDataChange Relationships |
| Parent Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
| StaffGroup | Non-Identifying | Zero or One to Zero or More | NewAssignedStaffGroupId | NO | |||
| Staff | Non-Identifying | Zero or One to Zero or More | NewAssignedStaffId | NO | |||
| Staff | Non-Identifying | Zero or One to Zero or More | NewLockedStaffId | NO | |||
| StaffGroup | Non-Identifying | Zero or One to Zero or More | NewReviewStaffGroupId | NO | |||
| Staff | Non-Identifying | Zero or One to Zero or More | NewReviewStaffId | NO | |||
| StaffGroup | Non-Identifying | Zero or One to Zero or More | PreviousAssignedStaffGroupId | NO | |||
| Staff | Non-Identifying | Zero or One to Zero or More | PreviousAssignedStaffId | NO | |||
| Staff | Non-Identifying | Zero or One to Zero or More | PreviousLockedStaffId | NO | |||
| StaffGroup | Non-Identifying | Zero or One to Zero or More | PreviousReviewStaffGroupId | NO | |||
| Staff | Non-Identifying | Zero or One to Zero or More | PreviousReviewStaffId | NO | |||
| FaaProcessExceptionAction | Non-Identifying | One To Zero or More | FaaProcessExceptionActionId | NO | |||
| FaaProcessExceptionStatus | Non-Identifying | One To Zero or More | NewFaaProcessExceptionStatusId | NO | |||
| FaaProcessExceptionStatus | Non-Identifying | Zero or One to Zero or More | PreviousFaaProcessExceptionStatusId | NO | |||
| Staff | Non-Identifying | One To Zero or More | LastModifiedUserId | NO |
| Child Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
| FaaProcessExceptionDataChange Check Constraints |
| Check Constraint Name | CheckConstraint |